////////////////////////////////////////////////////////////////////////////////
// Copyright 2006 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   CODE
// AUTHOR           :   Saint Peng 
// DATE CREATE      :   2006/01/05
// DESCRIPTION      :   a SCHEMA file for the function, CODE
//                  :   
//                  :   
//                  :   
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2006/01/05   Saint Peng      1.0                 source is generated.
//
//
//
////////////////////////////////////////////////////////////////////////////////

package com.erp.app.setup.catalogOption.schema;

import com.erp.framework.model.schema.MetaData;
import com.erp.framework.model.schema.TableSchema;

/**
* <p>A <strong>Schema</strong> stores the table meta information.
* The main purpose for this class is to validate the lengths of UniCode Characters,
* and notify the database to store UniCode characters from web browsers.
*
* @author          Saint Peng 
* @version 1.0     2006/01/05
* @since           FrameWork 1.0
*
*/
public class CatalogOptionDtlSchema extends TableSchema {

	public static final String TABLE_NAME = "T_CATALOG_OPTION_DTL";

	public CatalogOptionDtlSchema(){

		MetaData md = null;

		md = new MetaData();
		md.setColumnName("COMPANY_CODE");
		md.setVoPropertyName("companyCode");
		md.setColumnTitle("COMPANY_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_DTL_COMPANY_CODE");
		md.setWebLabelName("DEF DTL COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("lblSrchCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_COMPANY_CODE");
		md.setVoPropertyName("lblGridCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_COMPANY_CODE");
		md.setWebLabelName("DEF GRID COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("REF_MASTER_CODE");
		md.setVoPropertyName("refMasterCode");
		md.setColumnTitle("REF_MASTER_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_DTL_REF_MASTER_CODE");
		md.setWebLabelName("DEF DTL REF MASTER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_REF_MASTER_CODE");
		md.setVoPropertyName("lblSrchRefMasterCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_REF_MASTER_CODE");
		md.setWebLabelName("DEF SRCH REF MASTER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_REF_MASTER_CODE");
		md.setVoPropertyName("lblGridRefMasterCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_REF_MASTER_CODE");
		md.setWebLabelName("DEF GRID REF MASTER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("REF_CODE");
		md.setVoPropertyName("refCode");
		md.setColumnTitle("REF_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_DTL_REF_CODE");
		md.setWebLabelName("DEF DTL REF CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_REF_CODE");
		md.setVoPropertyName("lblSrchRefCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_REF_CODE");
		md.setWebLabelName("DEF SRCH REF CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_REF_CODE");
		md.setVoPropertyName("lblGridRefCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_REF_CODE");
		md.setWebLabelName("DEF GRID REF CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("REF_DESC");
		md.setVoPropertyName("dtlRefDesc");
		md.setColumnTitle("REF_DESC");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(2000);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(2000);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_REF_DESC");
		md.setWebLabelName("Detail Ref Description");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_REF_DESC");
		md.setVoPropertyName("lblSrchDtlRefDesc");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_REF_DESC");
		md.setWebLabelName("Ref Description");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_REF_DESC");
		md.setVoPropertyName("lblGridDtlRefDesc");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_REF_DESC");
		md.setWebLabelName("Ref Description");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("REF_STATUS");
		md.setVoPropertyName("dtlStatus");
		md.setColumnTitle("REF_STATUS");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_STATUS");
		md.setWebLabelName("DEF DTL STATUS");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_STATUS");
		md.setVoPropertyName("lblSrchDtlStatus");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_STATUS");
		md.setWebLabelName("DEF SRCH STATUS");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_STATUS");
		md.setVoPropertyName("lblGridDtlStatus");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_STATUS");
		md.setWebLabelName("DEF GRID STATUS");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("REF_1");
		md.setVoPropertyName("dtlRef1");
		md.setColumnTitle("REF_1");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_REF_1");
		md.setWebLabelName("DEF DTL REF 1");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_REF_1");
		md.setVoPropertyName("lblSrchDtlRef1");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_REF_1");
		md.setWebLabelName("DEF SRCH REF 1");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_REF_1");
		md.setVoPropertyName("lblGridDtlRef1");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_REF_1");
		md.setWebLabelName("DEF GRID REF 1");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("REF_2");
		md.setVoPropertyName("dtlRef2");
		md.setColumnTitle("REF_2");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_REF_2");
		md.setWebLabelName("DEF DTL REF 2");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_REF_2");
		md.setVoPropertyName("lblSrchDtlRef2");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_REF_2");
		md.setWebLabelName("DEF SRCH REF 2");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_REF_2");
		md.setVoPropertyName("lblGridDtlRef2");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_REF_2");
		md.setWebLabelName("DEF GRID REF 2");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("REF_3");
		md.setVoPropertyName("dtlRef3");
		md.setColumnTitle("REF_3");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_REF_3");
		md.setWebLabelName("DEF DTL REF 3");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_REF_3");
		md.setVoPropertyName("lblSrchDtlRef3");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_REF_3");
		md.setWebLabelName("DEF SRCH REF 3");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_REF_3");
		md.setVoPropertyName("lblGridDtlRef3");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_REF_3");
		md.setWebLabelName("DEF GRID REF 3");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DC_IND");
		md.setVoPropertyName("dtlDcInd");
		md.setColumnTitle("DC_IND");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_DC_IND");
		md.setWebLabelName("DEF DTL DC IND");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DC_DATE");
		md.setVoPropertyName("dtlDcDate");
		md.setColumnTitle("DC_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomSqlDate");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_DC_DATE");
		md.setWebLabelName("DEF DTL DC DATE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CREATE_USER");
		md.setVoPropertyName("createUser");
		md.setColumnTitle("CREATE_USER");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_CREATE_USER");
		md.setWebLabelName("DEF DTL CREATE USER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CREATE_DATE");
		md.setVoPropertyName("createDate");
		md.setColumnTitle("CREATE_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.sql.Timestamp");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_CREATE_DATE");
		md.setWebLabelName("DEF DTL CREATE DATE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("UPDATE_USER");
		md.setVoPropertyName("updateUser");
		md.setColumnTitle("UPDATE_USER");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_UPDATE_USER");
		md.setWebLabelName("DEF DTL UPDATE USER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("UPDATE_DATE");
		md.setVoPropertyName("updateDate");
		md.setColumnTitle("UPDATE_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.sql.Timestamp");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_UPDATE_DATE");
		md.setWebLabelName("DEF DTL UPDATE DATE");
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_DTL_SELECT");
		md.setWebLabelName("DEF DTL SELECT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_DTL_DELETE");
		md.setWebLabelName("DEF DTL DELETE");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setColumnName("SEQ");
		md.setVoPropertyName("dtlSeq");
		md.setColumnTitle("SEQ");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(5);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DTL_SEQ");
		md.setWebLabelName("DEF DTL SEQ");
		ts.add(md);
				
	}

}